using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Configuration;
using Bussiness.Config;     
using Bussiness.Entity;
namespace Bussiness.ManagerBase
{
                

     public abstract class CmsProductInfosManagerBase
    {
        public CmsProductInfosManagerBase()
        {
            Adapter.ConnectionString =  ConnectionConfig.ConnectionString;            
        }
                    
 
        /// <summary>
        /// Them moi du lieu
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity Insert(CmsProductInfosEntity obj)
        { 
            return (CmsProductInfosEntity) Adapter.Insert(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo khoa chinh cua object
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity Update(CmsProductInfosEntity obj)
        { 
            return (CmsProductInfosEntity)Adapter.Update(obj);             
        }
 
 
        public CmsProductInfosEntity Delete(CmsProductInfosEntity obj)
        { 
            return (CmsProductInfosEntity)Adapter.Delete(obj);             
        }
 


        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteById (CmsProductInfosEntity obj)
        { 
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"Id");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Id 
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteById (Guid Id )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Id = Id;  
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"Id");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Lang duoc set trong object
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteByLang (CmsProductInfosEntity obj)
        { 
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"Lang");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Lang 
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteByLang (string Lang )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Lang = Lang;  
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"Lang");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Packages duoc set trong object
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteByPackages (CmsProductInfosEntity obj)
        { 
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"Packages");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Packages 
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteByPackages (string Packages )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Packages = Packages;  
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"Packages");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ProductId duoc set trong object
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteByProductId (CmsProductInfosEntity obj)
        { 
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"ProductId");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ProductId 
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteByProductId (Guid ProductId )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.ProductId = ProductId;  
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"ProductId");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ProductName duoc set trong object
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteByProductName (CmsProductInfosEntity obj)
        { 
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"ProductName");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ProductName 
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteByProductName (string ProductName )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.ProductName = ProductName;  
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"ProductName");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Specification duoc set trong object
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteBySpecification (CmsProductInfosEntity obj)
        { 
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"Specification");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Specification 
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteBySpecification (string Specification )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Specification = Specification;  
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"Specification");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Title duoc set trong object
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteByTitle (CmsProductInfosEntity obj)
        { 
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"Title");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Title 
        /// </summary>
        /// <returns>CmsProductInfosEntity</returns>
        public CmsProductInfosEntity DeleteByTitle (string Title )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Title = Title;  
            return (CmsProductInfosEntity)Adapter.DeleteByField(obj,"Title");
        }

 
        /// <summary>
        /// Lay du lieu theo khoa chinh object
        /// </summary>
        /// <returns></returns>
        public CmsProductInfosEntity Select(CmsProductInfosEntity obj)
        { 
            return (CmsProductInfosEntity) Adapter.Select(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(CmsProductInfosEntity obj)
        { 
            return  Adapter.SelectWithCondition(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(CmsProductInfosEntity obj,SelectOptions option)
        {             
            return  Adapter.SelectWithCondition(obj,option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        { 
            return Adapter.SelectAll(new CmsProductInfosEntity());             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll(SelectOptions option)
        { 
            return Adapter.SelectAll(new CmsProductInfosEntity(),option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<CmsProductInfosEntity> SelectAllLST()
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new CmsProductInfosEntity()),new CmsProductInfosEntity());           
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<CmsProductInfosEntity> SelectAllLST(SelectOptions option)
        { 
            return (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new CmsProductInfosEntity(),option),new CmsProductInfosEntity());             
        }
 

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (CmsProductInfosEntity obj)
        { 
            return Adapter.SelectByField(obj,"Id");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Id",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByIdLST (CmsProductInfosEntity obj)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByIdLST (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Id",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (Guid Id )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Id = Id;  
            return Adapter.SelectByField(obj,"Id");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (Guid Id, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Id = Id;  
            return Adapter.SelectByField(obj,"Id",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByIdLST (Guid Id )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Id = Id;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByIdLST (Guid Id, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Id = Id;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Lang duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLang (CmsProductInfosEntity obj)
        { 
            return Adapter.SelectByField(obj,"Lang");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Lang duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLang (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Lang",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Lang duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByLangLST (CmsProductInfosEntity obj)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Lang"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Lang duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByLangLST (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Lang",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Lang 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLang (string Lang )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Lang = Lang;  
            return Adapter.SelectByField(obj,"Lang");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Lang duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLang (string Lang, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Lang = Lang;  
            return Adapter.SelectByField(obj,"Lang",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Lang 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByLangLST (string Lang )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Lang = Lang;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Lang"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Lang duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByLangLST (string Lang, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Lang = Lang;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Lang",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Packages duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPackages (CmsProductInfosEntity obj)
        { 
            return Adapter.SelectByField(obj,"Packages");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Packages duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPackages (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Packages",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Packages duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByPackagesLST (CmsProductInfosEntity obj)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Packages"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Packages duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByPackagesLST (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Packages",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Packages 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPackages (string Packages )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Packages = Packages;  
            return Adapter.SelectByField(obj,"Packages");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Packages duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPackages (string Packages, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Packages = Packages;  
            return Adapter.SelectByField(obj,"Packages",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Packages 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByPackagesLST (string Packages )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Packages = Packages;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Packages"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Packages duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByPackagesLST (string Packages, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Packages = Packages;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Packages",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProductId (CmsProductInfosEntity obj)
        { 
            return Adapter.SelectByField(obj,"ProductId");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProductId (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ProductId",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductId duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByProductIdLST (CmsProductInfosEntity obj)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ProductId"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductId duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByProductIdLST (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ProductId",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductId 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProductId (Guid ProductId )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.ProductId = ProductId;  
            return Adapter.SelectByField(obj,"ProductId");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProductId (Guid ProductId, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.ProductId = ProductId;  
            return Adapter.SelectByField(obj,"ProductId",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductId 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByProductIdLST (Guid ProductId )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.ProductId = ProductId;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ProductId"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByProductIdLST (Guid ProductId, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.ProductId = ProductId;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ProductId",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProductName (CmsProductInfosEntity obj)
        { 
            return Adapter.SelectByField(obj,"ProductName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProductName (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ProductName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductName duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByProductNameLST (CmsProductInfosEntity obj)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ProductName"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductName duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByProductNameLST (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ProductName",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductName 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProductName (string ProductName )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.ProductName = ProductName;  
            return Adapter.SelectByField(obj,"ProductName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProductName (string ProductName, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.ProductName = ProductName;  
            return Adapter.SelectByField(obj,"ProductName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductName 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByProductNameLST (string ProductName )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.ProductName = ProductName;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ProductName"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProductName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByProductNameLST (string ProductName, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.ProductName = ProductName;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ProductName",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Specification duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySpecification (CmsProductInfosEntity obj)
        { 
            return Adapter.SelectByField(obj,"Specification");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Specification duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySpecification (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Specification",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Specification duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectBySpecificationLST (CmsProductInfosEntity obj)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Specification"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Specification duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectBySpecificationLST (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Specification",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Specification 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySpecification (string Specification )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Specification = Specification;  
            return Adapter.SelectByField(obj,"Specification");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Specification duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySpecification (string Specification, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Specification = Specification;  
            return Adapter.SelectByField(obj,"Specification",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Specification 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectBySpecificationLST (string Specification )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Specification = Specification;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Specification"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Specification duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectBySpecificationLST (string Specification, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Specification = Specification;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Specification",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Title duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTitle (CmsProductInfosEntity obj)
        { 
            return Adapter.SelectByField(obj,"Title");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Title duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTitle (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Title",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Title duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByTitleLST (CmsProductInfosEntity obj)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Title"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Title duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectByTitleLST (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Title",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Title 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTitle (string Title )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Title = Title;  
            return Adapter.SelectByField(obj,"Title");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Title duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTitle (string Title, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Title = Title;  
            return Adapter.SelectByField(obj,"Title",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Title 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByTitleLST (string Title )
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Title = Title;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Title"),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Title duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<CmsProductInfosEntity> SelectByTitleLST (string Title, SelectOptions option)
        { 
            CmsProductInfosEntity obj = new CmsProductInfosEntity();
            obj.Title = Title;  
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Title",option),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectWithConditionLST (CmsProductInfosEntity obj)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj),new CmsProductInfosEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<CmsProductInfosEntity></returns>
        public List<CmsProductInfosEntity> SelectWithConditionLST (CmsProductInfosEntity obj,SelectOptions option)
        { 
            return  (List<CmsProductInfosEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj,option),new CmsProductInfosEntity());
        }

}
}
